Create a Report Adding Columns

Power users with an understanding of MySQL can start reports from scratch fro, the Fields & Data Objects widget, where you can search for objects, and drag them onto the working area.

Note: Before you begin, notice the Redo and Undo icons Redo and Undo at the top of the screen. You can undo up to 25 actions. Also notice the Cancel report creation and Start over options available on the File menu.

To create a report from scratch in the Report Working Area:

  1. Click Create Report on the top navigation.
  2. If the Fields & Data Objects widget is not visible, click Start adding columns.
  3. On the Fields & Data Objects widget browse the Data Object Catalog and Notable Objects or enter a keyword in the Filter content filed to narrow the list of options.
  4. Click an object's title to expand associated fields. Learn more about the object by clicking the Join Conditions, Preview, Show Details and Show key fields buttons.
  5. To add an item, drag it or click Add this field to my report. For more information about adding fields, see the Fields & Data Objects widget topic.
  6. Use the Tools and Options menus to configure your report with filters, sorting, grouping, and more. See the Tools Menu and Options Menu topics for details.
  7. When done, click File >> Save new Report.